An error occurred: (MySQLdb.ProgrammingError) (1146, "Table 'mydb.apt_list_4' doesn't exist") [SQL: select a.rgnCode, a.conAptCode, aptName, a.conAptNo, a.aptUnit, a.hoNum, c.sido, c.gugun, c.dong, c.bjri, a.aptAddr, a.doroAddr, a.conYear, a.useArea, ifnull(a.danjyHonum, 0) danjyHonum from (select a.rgnCode, a.conAptCode, b.conAptNo, if(min(a.aptName_max) = max(a.aptName_max), min(a.aptName_max), concat(min(a.aptName_max), '~', max(a.aptName_max))) aptName, b.aptUnit, ifnull(round(b.useArea, 2), 0) useArea, ifnull(b.hoNum, 0) hoNum, if(a.con_addrNum='', a.aptAddr, a.con_addrNum) aptAddr, if(a.con_doroAddr='', a.doroAddr, a.con_doroAddr) doroAddr, max(if(ifnull(a.useDateMin, '') ='', a.conYear_min, a.useDateMin)) conYear, max(a.hoNum) danjyHonum from mydb.apt_list_4 a left join mydb.apt_list_4 b on a.aptNo=b.aptCode where a.rgnCode like %s and a.conAptCode = %s and b.aptUnit is not null and a.rgnCode=a.con_rgnCode and a.conAptCode=b.conAptCode and b.conAptNo is not null group by a.rgnCode, conAptCode, conAptNo, b.aptUnit, useArea, hoNum, aptAddr, doroAddr ) a left join region_list c on a.rgnCode = c.rgnCode order by a.aptUnit ] [parameters: ('26410108%', '1048466')] (Background on this error at: https://sqlalche.me/e/20/f405)
※ 열이름 클릭 정렬
지 역 명 사진 매물종류 유형 가격 입주시기 면적(㎡) 용도지역 지목 등록자(일)
임대수익률 계산기
적정주택가격 계산기
유용한 부동산 사이트 모음